I try to setup a postresql backup resource including one postgresql db. In modify resource group, application sessings i try to add custom configuration settings as follows: ARCHIVE_LOG_ENABLE=Y ARCHIVE_LOG_RETENTION=15 ARCHIVE_LOG_DIR=/p99/databasename/archive ARCHIVE_LOG_RECURSIVE_SEARCH=N and for the parameter ARCHIVE_LOG_EXT i did not succeed to declare the correct value. All WAL logs ends with a ".wal" how do i address that in tis configuration? Even leave the vale blanc is not allowed and not setting ARCHIVE_LOG_EXT did not work.
... View more
Setting up Snapcenter to manage snapmirror after the backup. I check the box for snapmirror and there is a relationship for all drives: Data, Logs, and DLM which seems to be the replacement for snapinfo. Regardless it seems to replicate the snapshots to the cluster protecting them, but it constantly give warnings below. Are these erroneous warnings? has anyone else had this issue? Activity 'Replicating to Secondary' failed with error: You have selected a backup policy indicating that you want to backup to a secondary storage system. Some of the resources you want to backup are located on a storage system that does not have replication relationships set up. Establish your SnapVault or SnapMirror relationships before proceeding. Microsoft SQL Server ms-utility-sql.regent.edu MS-UTILITY-SQL SQL Daily Full and Logs 05/19/2025 10:31:01 AM 0.00:01:38 Warning Failed on 'MS-UTILITY-SQL': Activity 'Replicating to Secondary' failed with error: You have selected a backup policy indicating that you want to backup to a secondary storage system. Some of the resources you want to backup are located on a storage system that does not have replication relationships set up. Establish your SnapVault or SnapMirror relationships before proceeding. Activity 'Creating SQL Backup' failed with error: The following activities failed:Replicating to Secondary,Grouping Resources. Please check the activities for detailed error message. SnapCenter Backup Report Updated on: 05/19/2025 11:30:17 AM 05/19/2025 11:30:17 AM
... View more
Hi All, I have a snapcenter 6.1, and mount a lun of the netapp iscsi service, and install postgresql 15.11-1 on it, I create a postgresql backup , a failed message: "SCC-00164: Application quiesce for the plug-in [PostgreSQL] failed with exit code [1] and with error : Operation [QUIESCE] failed with Exception [java.util.concurrent.ExecutionException: java.lang.NoClassDefFoundError: com/sun/jna/LastErrorException] SCC-00161: Application unquiesce for the plug-in [PostgreSQL] failed with exit code [1] and error : Operation [UNQUIESCE] failed with Exception [java.util.concurrent.ExecutionException: java.lang.NoClassDefFoundError: com/sun/jna/LastErrorException]." I have installed java se development 11.0.26. Anybody know how to resolv it ?
... View more
We have an SQL script which deletes a backup from a resource group, deletes clones from that backup, takes a new backup, and takes a new clone from the new backup. This happens each morning. Since we updated to Snapcenter 5.0 due to a bug the Where-Object BackupName -Match "^A.*" functionality doesn't work. I am listing below the part of the script which fails to define the variables: $oldBack=Get-SmBackup -AppObjectId M4SQLXXXXRO3\M4SQLXXXXRO3\XXX_PROD | Where-Object BackupName -Match "^A.*" | Select-Object -first 1 $oldClone=Get-SmClone -BackupId $oldBack.BackupId NetApp suggests to use Select-String. However, with that I cannot understand how I can define the object. Any ideas how to define an object in Snapcenter 5.0. We understand that this is fixed in 6.0 but it's hard for us to plan an update to that version as all plug-in hosts need to be rebooted to update powershell and .net versions. I am pasting below some more of the script for reference: ### DELETING PREVIOUS CLONE DB ### $oldBack=Get-SmBackup -AppObjectId M4SQLXXXXRO3\M4SQLXXXXRO3\XXX_PROD | Where-Object BackupName -Match "^A.*" | Select-Object -first 1 $oldClone=Get-SmClone -BackupId $oldBack.BackupId Remove-SmClone -CloneName $oldClone.CloneName -PluginCode SMSQL -Confirm:$false Start-Sleep -Seconds 240 Remove-SmBackup -BackupIds $oldBack.BackupId -Confirm:$false Start-Sleep -Seconds 240 ### CREATING NEW BACKUP ### New-SmBackup -ResourceGroupName XXX_XXXX_Automation -Policy Test start-sleep -Seconds 300 ## CREATING THE CLONE ### $newBack=Get-SmBackup -AppObjectId M4SQLXXXXRO3\M4SQLXXXXRO3\XXX_PROD | Where-Object BackupName -Match "^A.*" | Select-Object -Last 1 New-SmClone -backupname $newBack.BackupName -Resources @{"Host"="XXXXXXXXXX";"Type"="SQL Database";"Names"="M4SQLXXXXRO3\M4SQLXXXXRO3\XXX_PROD"} -CloneToInstance XXXXXXXXX\XXXXXXXXX -AutoAssignMountPoint -CloneName XXX_PROD_SNAP -AppPluginCode SMSQL
... View more